﻿CREATE TABLE [dbo].[PowerPlan] (
    [PowerPlanID] INT           IDENTITY (1, 1) NOT NULL,
    [Name]        VARCHAR (200) NULL,
    [Description] VARCHAR (200) NULL,
    [isActive]    BIT           NULL,
    [ServerID]    INT           NULL,
    CONSTRAINT [PK_PowerPlan] PRIMARY KEY CLUSTERED ([PowerPlanID] ASC),
    CONSTRAINT [FK_PowerPlan_Server] FOREIGN KEY ([ServerID]) REFERENCES [dbo].[Server] ([ServerID])
);

